package com.qzimp.fujiancuo.mapper;

import com.mybatisflex.core.BaseMapper;
import com.qzimp.fujiancuo.entity.Enterprise;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 *  映射层。
 *
 * @author 吴宗波
 * @since 2024-11-21
 */
public interface EnterpriseMapper extends BaseMapper<Enterprise> {

    @Select("SELECT e.*, c.* FROM tb_enterprise e JOIN tb_cuo c ON e.cuo_id = c.id WHERE c.id = #{cuoId}")
    List<Enterprise> queryEnterpriseByCuoId(Integer cuoId);
}
